LINK examples

There are two types of links that can be built in iLoader. You can link tables by linking the primary key on one table with a foreign key on another table. Alternatively, you can link two key fields to create a new field.

The following example shows a link between the family and person table.

[test].[family].[FID] , [test].[person].[FID]

The following example links the Household_ID and Postcode from the Household table to form a new field called Postcode_ID.

LINK_KEY = [Demo].[Household] , Postcode_ID , {[Household_ID] + [Postcode]}

• Data Engineering
  • Using The Data Transformation Wizard
  • Creating User Variables Within iLoader
  • Using The Link Wizard
  • Link Wizard - File Structure
  • LINK Examples
  • Data Transformation Commands
  • Data Transformation Examples